package com.example.demo.Mappers;

import com.example.demo.beans.Lis_jysqList;
import com.example.demo.beans.Lis_mx_TempBean;
import com.example.demo.beans.Lis_xzjgBean;
import com.example.demo.beans.LisdjBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by Administrator on 2018-10-17.
 */
@Mapper
public interface GetLisSqMapper {
    @Select("select  patientName,repId,repName,repType,sendTime,repTime,sendDeptId,sendDeptName,repDeptId,repDeptName,repDoctId,repDoctName,checkDoctId,checkDoctName,status,reserved from Auto_View_lis_jysq where cardNo=#{cardNo} and sendTime>=#{startDate} and sendTime<=#{endDate} ")
    List<Lis_jysqList> getLisJysq(@Param("cardNo")String cardNo,@Param("startDate")String startDate,@Param("endDate")String endDate);

    @Select("select cardNo, patientName,repId,repName,repType,sendTime,repTime,sendDeptId,sendDeptName,repDeptId,repDeptName,repDoctId,repDoctName,checkDoctId,checkDoctName,status,reserved from Auto_View_lis_jysq where sendTime>=#{startDate} and sendTime<=#{endDate}")
    List<LisdjBean> GetLisInfo(@Param("startDate")String startDate, @Param("endDate")String endDate);
    @Select("select itemCode,itemName,quantitative,qualitative,IsDisplay,reference,refRangeMin,refRangeMax,itemUnit,reserved from Auto_View_Lis_jymx where jyxh=#{jyxh}")
    List<Lis_mx_TempBean> getTempLis(@Param("jyxh")String jyxh);
    @Select("select RTRIM(bm)bm,RTRIM(mc)mc  from lis_xzjg where stop='0'")
List<Lis_xzjgBean> getxzjg();
}
